DEFAULT TOPIC TITLE
This is a context-sensitive Help file that is called from an application.


Fill selected cells with the contents of the cells from the bottom of the selection.


Fill selected cells with the contents of the cells from the right of the selection.


Fill selected cells with the contents of the cells from the left of the selection.


Fill selected cells with the contents of the cells from the top of the selection.


Fill the selection with a series. The series could be a number sequence or custom list.


Choose the start value for the series. By default, the current cell contents will display here.

The starting value can be a number or a member of a custom list (e.g. "Jan") or text ending in a number (e.g. "Anytext3").


Increase and decrease the starting value. This will work for numbers, custom lists or text ending with a numeric.


The value to increment the series by.


Increase and decrease the step value.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Erase all cell formatting (font, background color, number format) as well as the contents.


Erase the cell contents only if the cell contains a value (that is anything other than a formula).


Removes all formulas but leaves the result. This permanently "freezes" formulas. Other cells containing plain numbers or text are unchanged.


Erases cell content but leaves cell format intact.


Erase all cell formatting (font, background color, number format) but leave the contents unchanged.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Move cells from below the current selection upwards to fill the deleted area.


Move cells from the right of the current selection left to fill the deleted area


Available only on cell insert.


Available only on cell insert.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Set the width of the current column (or selected columns) in units of 1/96th of an inch.


Increase or decrease the width of the current column (or selected columns) in units of 1/96th of an inch.


Set the column width to the default value. The default value can be specified under Tools/Options.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Increases or decreases the column width for snug fit of the widest cell in the column.


Enter a new range name here. Click the Add button to save it.


Displays the cell range for the current selection.


Displays all the named ranges in the current spreadsheet.


Add the new range name.


Delete the currently selected named range.


Deflate all the named ranges in the spreadsheet.


Click this button to close the dialog.


Left justify text within the cell. This is the default for text cells. If the content is wider than the cell, and the surrounding cells are blank, the text will extend beyond the right edge of the cell.


Center text within the cell. If the content is wider than the cell, and the surrounding cells are blank, the text will extend beyond the cell to the left and right.


Right justify text within the cell. This is the default for numeric cells. If the content is text, is wider than the cell, and the surrounding cells are blank, the text will extend beyond the left edge of the cell.


Cell contents will be aligned to the top of the cell. You will only notice this effect if your row height is substantially bigger than the font size.


Cell contents will be aligned to the middle of the cell. You will only notice this effect if your row height is substantially bigger than the font size.


Cell contents will be aligned to the bottom of the cell. You will only notice this effect if your row height is substantially bigger than the font size. This is the default vertical alignment.


Text will reformat to fit the cell width, occupying several lines if necessary.


Previews current settings.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Lock the cell. Prevents the cell content from being changed once the spreadsheet is in protect more (see Tools/Protect). In design mode, locked cells are shown with hatching and can be modified.


Hide the cell. Prevents the cell content from being displayed once the spreadsheet is in protect more (see Tools/Protect). In design mode, hidden cells are shown with hatching and the contents is visible. You will probably want to lock hidden cells as well - otherwise, it is easy to overwrite hidden cells when the spreadsheet is protected.


Don't display error messages (like #REF, #DIV0) in the cell contents. Only applies to formula fields.


If the result of a formula is zero, don't display it. Applies to manually enter 0's as well as formulae.


Allow contents of cells or fields to be updated at either end. For example, if cell A1 contains "May" and A2 contains =A1 setting this option will allow you the enter "June" in either A1 or A2.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Select sorting by rows or columns if the current selection covers more than one row and column.


Choose the primary row or column to sort on. This row or column must lie within the current selection.


Sort ascending, that is A..Z or 1....9.


Sort descending, that is Z..A or 9..1.


Choose standard sort order (Normal) or order by custom list.


Choose to treat capital and lowercase letters the same.


Choose the secondary row or column to sort on. This row or column must lie within the current selection.


Sort ascending, that is A..Z or 1....9.


Sort descending, that is Z..A or 9..1.


Choose standard sort order (Normal) or order by custom list.


Choose to treat capital and lowercase letters the same.


Choose the third row or column to sort on. This row or column must lie within the current selection.


Sort ascending, that is A..Z or 1....9.


Sort descending, that is Z..A or 9..1.


Choose standard sort order (Normal) or order by custom list.


Choose to treat capital and lowercase letters the same.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Choose whether or not to paste cell formats (fonts, numeric formats, alignment, borders and background colors). If both Values and Formulas are clear, only cell formats are pasted.


Choose whether or not to paste values (that is cell contents other than formulas). If this is checked and Formulas is clear, all formulas will convert to values - only the results are pasted.


Choose whether or not to paste formulas. If this is clear and Values is checked, all formulas will convert to values - only the results are pasted.


Paste contents "as is".


Adds values in the copied range to the values in the target range.


Subtracts values in the copied range from the values in the target range.


Multiply values in the copied range with values in the target range.


Divides values in the target range by the values in the copied range.


Transpose the range on paste. This means rows are turned into columns and visa-versa. For example

1	2	1	3

transposes to:

3	4	2	4


Paste the contents as normal.


Paste a link back to the copied range. For example, if you select and copy A1 through A3, and Paste Link to D1 through D3 then D1 will contain the formula: =A1.


Paste a hot link back to the copied range. For example, if you select and copy A1 through A3, and Paste Hot Link to D1 through D3 then D1 will contain the formula: ! A1. As well as displaying the contents of A1, it allows you to edit the contents at both ends.


Closes this dialog without saving any changes you have made.


Display page breaks, using a blue line, as they occur horizontally.

At print time, your spreadsheet will be divided up to fit the paper, starting at the top left and moving right before moving down. You can select Vertical/Column at the same time to show all page breaks.


Display page breaks, using a blue line, as they occur vertically.

At print time, your spreadsheet will be divided up to fit the paper, starting at the top left and moving right before moving down. You can select Horizontal/Row at the same time to show all page breaks.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Set the outer edge of a range of cells to the current line style and color.


Set the left edge of a cell, or range of cells, to the current line style.


Set the right edge of a cell, or range of cells, to the current line style.


Set the top edge of a cell, or range of cells, to the current line style.


Set the bottom edge of a cell, or range of cells, to the current line style.


Sets the line style for current border.


Sets the line style for current border.


Sets the line style for current border.


Sets the line style for current border.


Sets the line style for current border.


Sets the line style for current border.


Sets the line style for current border.


Sets the line style for current border.


Sets the color for the current border.


Previews current settings.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Only available when deleting cells.


Only available when deleting cells.


Move cells in the current selection to the right when the new cells are inserted.


Move cells in the current selection downwards when the new cells are inserted.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Set the height of the current row (or selected rows) in units of 1/96th of an inch.


Increase or decrease the height of the current row (or selected rows) in units of 1/96th of an inch.


Set the row height to the default value. The default value can be specified under Tools/Options.


Increases or decreases the row height for snug fit of the tallest cell in the column.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Fix the object in absolute location relative to the spreadsheet and fix the object size.

For example, if the object appeared 1 inch from the top and left of the spreadsheet, it would remain so, regardless of changes to column width and row height or insertion and deletion of cells.


Location of the object is set relative to the cell under the top left corner of the object. If columns are inserted to the left of the object, the object will move with this cell (to the right). Similarly, if the height of a row above the object is altered, the object will move accordingly.

The size of the object is fixed.


The size of the object increases or decreases with changes to the row height or column width of cells under the object.

For example, if you sized an object to exactly fill a cell, the object would change size to match any adjustments to the height or width of the cell.

Location of the object is set relative to the cell under the top left corner of the object. If columns are inserted to the left of the object, the object will move with this cell (to the right). Similarly, if the height of a row above the object is altered, the object will move accordingly.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Enter your text for the left part of the header / footer here. You can have multiple lines - use Ctrl-Enter to start a new line.


Enter your text for the center part of the header / footer here. You can have multiple lines - use Ctrl-Enter to start a new line.


Enter your text for the right part of the header / footer here. You can have multiple lines - use Ctrl-Enter to start a new line.


Choose font for current header / footer section. You can have different fonts for the left, center and right sections of the header and footer but each section can only have a single font.


Insert filename. This appears as &F in your header or footer - at print or preview time, the filename will be shown. To remove the filename, simply delete the &F.


Insert page number. This appears as &P in your header or footer - at print or preview time, the page number will be shown. You can add text to this, for example: " - &P - " or "Page &P". To remove the filename, simply delete the &P.


Insert date. This appears as &D in your header or footer - at print or preview time, the current date will be shown. To remove the date, simply delete the &D.


Insert time. This appears as &T in your header or footer - at print or preview time, the current time will be shown. To remove the time, simply delete the &T.


Specifies the distance from the edge of the paper to the header or footer. This setting should always be less than the top or bottom margin for header and footer respectively. If you set this to be bigger, the header or footer won't be shown.


Enter the start value for the page numbering sequence. The default is 1.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Enter the desired destination. If the category is a named range or object, its name will be displayed in the drop down menu.


Go To will move to a specific spreadsheet cell.


Go To will move to a specific range.


Go To will move to a specific page.


Go To will move to and select a specific column.


Go To will move to and select a specific row.


Go To will move to a specific object.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Select chart to view.


View the chart.


Closes this dialog.


Enter your text for the left part of the header / footer here. You can have multiple lines - use Ctrl-Enter to start a new line.


Enter your text for the center part of the header / footer here. You can have multiple lines - use Ctrl-Enter to start a new line.


Enter your text for the right part of the header / footer here. You can have multiple lines - use Ctrl-Enter to start a new line.


Choose font for current header / footer section. You can have different fonts for the left, center and right sections of the header and footer but each section can only have a single font.


Insert filename. This appears as &F in your header or footer - at print or preview time, the filename will be shown. To remove the filename, simply delete the &F.


Insert page number. This appears as &P in your header or footer - at print or preview time, the page number will be shown. You can add text to this, for example: " - &P - " or "Page &P". To remove the filename, simply delete the &P.


Insert date. This appears as &D in your header or footer - at print or preview time, the current date will be shown. To remove the date, simply delete the &D.


Insert time. This appears as &T in your header or footer - at print or preview time, the current time will be shown. To remove the time, simply delete the &T.


Specifies the distance from the edge of the paper to the header or footer. This setting should always be less than the top or bottom margin for header and footer respectively. If you set this to be bigger, the header or footer won't be shown.


Sets the number of columns for the current and subsequent spreadsheets. The default is 256, which is also the maximum.


Increase and decrease the number of columns.


Sets the number of rows for the current and subsequent spreadsheets. The default is 65536, which is also the maximum.


Increase and decrease the number of rows.


Sets the default column width for the current and subsequent spreadsheets, in units of 1/96th of an inch. All columns that have not already been sized manually will be reset to the new default.

When you first install the Spreadsheet, this setting is 80.


Increase and decrease the column width.


Sets the default row height for the current and subsequent spreadsheets, in units of 1/96th of an inch. All rows that have not already been sized manually will be reset to the new default.

When you first install the Spreadsheet, this setting is 16.


Increase and decrease the row height.


Sets the default zoom for factor for new spreadsheets. The default is 100.


Increase and decrease the default zoom.


Display grid lines for the current and subsequent spreadsheets.


Display page breaks for the current and subsequent spreadsheets.


Select the unit of measure for page margins and other settings.


Set the default autocalc mode for the current and subsequent spreadsheets. Normally this should be checked (set to on). Otherwise, you'll need to manually recalc (Shift-F9)  to update formulas.


Record spreadsheet edits so they can be undone with the undo button:

 .


Add, edit and delete leading and trailing strings. These are for numeric formatting available under Format/Number (for example, the number 12 could be formatted to display as 12oz).

Edit the text directly or use Ctrl-Enter to insert blank lines for new entries.


Sets the left margin for the current and subsequent spreadsheets.

You can also set margins for the current spreadsheet using File/Page Setup.


Sets the right margin for the current and subsequent spreadsheets.

You can also set margins for the current spreadsheet using File/Page Setup.


Sets the top margin for the current and subsequent spreadsheets.

You can also set margins for the current spreadsheet using File/Page Setup.


Sets the bottom margin for the current and subsequent spreadsheets.

You can also set margins for the current spreadsheet using File/Page Setup.


The spell checker will always generate a list of suggestions for each miss-spelt word.


Choose whether to include your own custom list of words or not in the spell check.


Locate the personalized dictionary. By default, this is USER.LEX and is where words that are "added" to the dictionary during spell check are stored.


Click this button to make your choice.


If you have a dictionary for more than one language, select it here.


Show all spelling errors in the color below as soon as they are entered in the spreadsheet.


Select a color to display all spelling errors when Auto recognize is on.


Select an ordered list for editing or removal. Use NEW LIST to create new custom lists. Ordered lists are typically days of the week or months, and are automatically filled in on drag-copy of a cell containing a member item. For example, enter "Jan" in cell A1 and use drag-copy to fill A2 to A12 with the remaining months.


Displays individual items from the current ordered list. You can edit the items in this list, or add new ones (use Ctrl-Enter to create new line). To save the modifications, click the Modify button.

To create a new list, make sure NEW LIST is selected in custom lists, add some items in List Entries and click the Add button


Add the current set of List Entries as a new custom list.


Remove the current custom list.


Update the current custom list with any changes made in the List Entries box.


Indicates whether the field control is based on a listbox (choose from a list of values) or a combo box (choose from a list of values or enter a new one).


Check this option to enable selection of a series of values to fill the listbox or combo box.


Fill the listbox or combo box with values from field in a database table, selected below.


Type in a series of values to fill the listbox or combo box. For example, the contents of Choices could be:

Spring

Summer

Autumn

Winter

Check "Use Choices" to enable this box.


Select a database name. If you cannot remember the name (and the path) use the browse button [...] to the right.


Open a browse dialog so you can browse and select a database to merge with.


Select a data source from the drop-down list. This can be a table, relation or query.

You must select a database before you can select a data source.


Select a field from the drop-down list to act as a search on list (the lookup).

You must select a database and data source before you can select a data item.


Select a field to display as a result of the lookup.


Select from:

Edit -  plain edit control for text, numbers or formula.

Checkbox - has two values 0 and 1 which can be displayed as True/False, On/Off etc.

Listbox - choose from a list of values, can be a series of fixed values or could be filled from a database.

Combo - same as a list box but combo allows new values to be entered.


Continue on to the next page of the wizard.


Go to previous page of the wizard.


Apply current settings to finish the wizard.


Closes the wizard without saving any changes you have made.


Select a name for the field. The name can be used in formulas in other cells to reference the contents of this field.


Make the field a standard formula field. This is has the same properties as a spreadsheet cell.


The field will be a database field. A database field can be browsed, mail merged and its contents can be edited.


Check your desired options.


Check your desired options.


Allow the underlying cell to be changed at the same time as current cell.

For example, =A1 in cell A2 normally reflects whatever A1 reads. With Edit Source selected, you can enter data into either A1 or A2 and have both cells updated. This is a "Hot Link".

Edit Source is particularly useful when linking to database from Write or Spreadsheet. It allows you to change the contents of the database field while browsing the data in Write or Spreadsheet.


Show control only if cell is inactive. This will mask the data.


If the result of a formula is zero, don't display it. Applies to manually enter 0's as well as formulae.


Don't display error messages (like #REF, #DIV0) in the cell contents. Only applies to formula fields.


Select a database name. If you cannot remember the name (and the path) use the browse button [...] to the right.


Open a browse dialog so you can browse and select a database to merge with.


Select a data source from the drop-down list. This can be a table, relation or query.

You must select a database before you can select a data source.


Select a field from the drop-down list.

You must select a database and data source before you can select a data item.


Select this if you want to be able to browse through the database records.


Enter a formula. The same rules apply as for formulas in spreadsheet - they must start with an = sign (or other mathematical operator) and can use any of the built in functions.

Plain text or numbers can also be entered - again, just like a spreadsheet.


Choose from the list of built-in functions.


Show the formula instead of the result of the formula.


Select the checked style.


Select the unchecked style.


Display this value if control is checked.


Display this value if control is unchecked.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Turn off the border.


Use the settings defined in Pen Style. By default, this will be a thin, plain, single line.


Creates a raised 3D effect. To see this effect properly you need to set the text box back-color to be the same as the page background (and this should not be white).


Creates a 3D sunken effect. To see this effect properly you need to set the text box back-color to be the same as the page background (and this should not be white).


Puts a dropped shadow around the text box


Use the settings defined in Pen Style and draw the border as a double line. By default, this will be a thin, plain, double line.


Sets the fill pattern of the interior of the object. If you want a simple color (the default) select Solid. If you want the shape to be transparent, select None.


Sets the pen style for the outline of the shape. If you don't want an outline to appear around a shape, select None.


Make the field a standard formula field. This is has the same properties as a spreadsheet cell.


The field will be a database field. A database field can be browsed, mail merged and its contents can be edited.


Select a name for the field. The name can be used in formulas in other cells to reference the contents of this field.


Enter a formula. The same rules apply as for formulas in spreadsheet - they must start with an = sign (or other mathematical operator) and can use any of the built in functions.

Plain text or numbers can also be entered - again, just like a spreadsheet.


Choose from the list of built-in functions.


Show the formula instead of the result of the formula.


Select a database name. If you cannot remember the name (and the path) use the browse button [...] to the right.


Open a browse dialog so you can browse and select a database to merge with.


Select a data source from the drop-down list. This can be a table, relation or query.

You must select a database before you can select a data source.


Select a field from the drop-down list.

You must select a database and data source before you can select a data item.


Select this if you want to be able to browse through the database records.


Indicates whether the field control is based on a listbox (choose from a list of values) or a combo box (choose from a list of values or enter a new one).


Check this option to enable selection of a series of values to fill the listbox or combo box.


Fill the listbox or combo box with values from field in a database table, selected below.


Type in a series of values to fill the listbox or combo box. For example, the contents of Choices could be:

Spring

Summer

Autumn

Winter

Check "Use Choices" to enable this box.


Select a database name. If you cannot remember the name (and the path) use the browse button [...] to the right.


Open a browse dialog so you can browse and select a database to merge with.


Select a data source from the drop-down list. This can be a table, relation or query.

You must select a database before you can select a data source.


Select a field from the drop-down list to act as a search on list (the lookup).

You must select a database and data source before you can select a data item.


Select a field to display as a result of the lookup.


Left align cell contents within the cell.


Center the cell contents across the cell.


Right align cell contents within the cell.


Align the cell contents to the top of the cell.


Center the cell contents vertically within the cell.


Align the cell contents to the bottom of the cell.


Wrap the text to make two or more lines if the cell content is too long to fit on one line.

When editing the text, Ctrl-Enter starts a new line.


Preview current settings.


Choose a numeric format from the list.


Previews current settings.


Select a data source to merge with.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Click this button to make your choice.


Select a database name. If you cannot remember the name (and the path) use the browse button [...] to the right.


Open a browse dialog so you can browse and select a database to merge with.


Select a data source from the drop-down list. This can be a table, relation or query.

You must select a database before you can select a data source.


Select a field from the drop-down list.

You must select a database and data source before you can select a data item.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Select a control from the list.


Display the control as an icon only.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Enter a password to protect the spreadsheet (turn on protection for hidden and  locked cells).

You can choose not to enter a password - leave this blank. The spreadsheet will still be protected.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Select a function from the list. Use the tabs to select particular types of functions or use the All tab to display all the functions in one go.

You can click on the function list and use "first letter selection" - select the functions beginning with "R" by typing R.


Include a text version of the parameters required in this function. These will need editing and turning into values or cell references as appropriate.


Displays the current function with its arguments.


A brief description of the current function.


Set the number of digits that will be displayed after the decimal point.


Increase or decrease the number of decimal places.


Separate thousands with a comma (or period depending on digit grouping symbol in the Windows Regional Settings of Control Panel).


Display all negative numbers in brackets.

Note you can set both of "Negatives in Brackets" and "Negatives in Red".


Display all negative numbers in a red font.

Note you can set both of "Negatives in Red" and "Negatives in Brackets".


Display month before day (US style date format).


Display day before month (Non US style date format).


Display month as digits, for example 12 for December.


Display abbreviated month - Jan, Feb, Mar, Apr....


Display full month - January, February, March...


Display date without year.


Double digit year display. The year 2000 switch over is achieved by using 1930 as a base point as follows:

30 for 1930	98 for 1998

00 for 2000	20 for 2010

29 for 2029


Display year with 4 digits.


Set the date separator. Choose from none (blank), "-", "\" or type in your own character.

Separator applies to both long and short date formats.


Include a time display with the date.


Display time with seconds.


Display as 0-12 with AM and PM indicators. Clear this box to use 24 hour notation.


Separate thousands with a comma (or period depending on digit grouping symbol in the Windows Regional Settings of Control Panel).


Display all negative numbers in brackets.

Note you can set both of "Negatives in Brackets" and "Negatives in Red".


Display all negative numbers in a red font.

Note you can set both of "Negatives in Red" and "Negatives in Brackets".


Choose between Auto (the nearest representation of the number as a fraction) or round the fraction to the nearest 100th, 10th, 16th, 8th or quarter.


Set the number of digits that will be displayed after the decimal point.


Increase or decrease the number of decimal places.


Separate thousands with a comma (or period depending on digit grouping symbol in the Windows Regional Settings of Control Panel).


Display all negative numbers in brackets.

Note you can set both of "Negatives in Brackets" and "Negatives in Red".


Display all negative numbers in a red font.

Note you can set both of "Negatives in Red" and "Negatives in Brackets".


Remove any trailing or leading text from the number.


Display numbers using the below as preceding text.


Display numbers with the below text following the number.


Select the text string to display with the numbers.

Choose from the drop-down list or enter your own text.


Set the number of digits that will be displayed after the decimal point.


Increase or decrease the number of decimal places.


Separate thousands with a comma (or period depending on digit grouping symbol in the Windows Regional Settings of Control Panel).


Display all negative numbers in brackets.

Note you can set both of "Negatives in Brackets" and "Negatives in Red".


Display all negative numbers in a red font.

Note you can set both of "Negatives in Red" and "Negatives in Brackets".


Set the number of digits that will be displayed after the decimal point.


Increase or decrease the number of decimal places.


Display time with seconds


Display as 0-12 with AM and PM indicators. Clear this box to use 24 hour notation.


Choose a numeric format from the list.


Previews current settings.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Choose an item from the list.


Choose an item from the list.


Choose an item from the list.


Choose an item from the list.


Choose an item from the list.


Color of the background - the area outside the chart.


Apply "depth" to a chart - as though it were a solid 3D object. Set the amount of depth in the 3D Depth box.


The depth of the chart is % of X-axis.

Setting the depth to 100% will make the chart as deep as it is tall. 3D Depth can be more than 100%.


Use the arrows to select your preferred value.


As well as depth, allow the view point to be rotated left to right (X angle) and top to bottom (Y angle).

"3D Chart" must be selected before "Full 3D View" can be selected.


Y-angle affects the left to right perspective the chart is viewed in.

Setting this to 0 will be as though you are viewing the chart from the front and 90 will be as though viewing the right edge of the chart.


Use the arrows to select your preferred value.


X-angle affects the top to bottom perspective the chart is viewed in.

Setting this to 0 will be as though you are viewing the chart from floor level and 90 will be as though you are suspended directly above the chart.


Use the arrows to select your preferred value.


The color for the area within the chart and underneath the actual bars, points etc.


Check your desired options.


Let Chart decide on start, end and increment for the Y-axis values.


Start the Y-axis (horizontal axis) at the entered value.

Data points falling below this value will not be displayed.


Use the arrows to select your preferred value.


End the Y-axis at the entered value.

The tops of data points falling above this value will not be displayed.


Use the arrows to select your preferred value.


Choose the interval for Y-axis labeling.

For example, entering 1 will cause the chart to display 0, 1, 2,  3, 4 and so on. Entering 5 will cause it to display 0, 5, 10, 15 and so on.

If the increment is too small (chart would have to fit too many numbers on the display), the increment is automatically increased.


Use the arrows to select your preferred value.


Standard scaling for Y-axis labels: 0, 1, 2, 3, 4 and so on are evenly spaced.


Log scaling for Y-axis labels: 1, 2, 3, 4 and so on are scaled according to the log of the number.


Start the X-axis at the entered value.

Data points falling below this value will not be displayed.


Use the arrows to select your preferred value.


End the X-axis at the entered value.

Data points falling above this value will not be displayed.


Use the arrows to select your preferred value.


Choose the interval for X-axis labeling.

For example, entering 1 will cause the chart to display 0, 1, 2,  3, 4 and so on. Entering 5 will cause it to display 0, 5, 10, 15 and so on.

If the increment is too small (chart would have to fit too many numbers on the display), the increment is automatically increased.


The number of decimal places used to display the values marking the Y Axis.


Use the arrows to select your preferred value.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Preview of the current settings.


Display a value along side each data point in the every series.


Depth of the line plotted when drawing a chart in 3D style.

The value entered can be anywhere between 0 (the thinest rendering) and 24 (the thickest).


Choose a marker type for the current series. This only applies to charts displaying data points.


Rename the current series (the name is used in legend display).


Select a series.

You can rename and set colors and patterns for each individual series in the chart.


Choose a color for the current series.


Display points for every point in the data range. This only applies to charts displaying a line connecting each data point.


Choose a pattern to display the current series in.


Select a font for the current title.

Fonts, font sizes, color and effects must be set individually for the Top, Bottom Left and Right titles.


Select a font style for the current title.

Fonts, font sizes, color and effects must be set individually for the Top, Bottom Left and Right titles.


Select a font size for the current title.

Fonts, font sizes, color and effects must be set individually for the Top, Bottom Left and Right titles.


Select a font color for the current title.

Fonts, font sizes, color and effects must be set individually for the Top, Bottom Left and Right titles.


Apply a strikeout font effect to the current title.

Fonts, font sizes, color and effects must be set individually for the Top, Bottom Left and Right titles.


Apply an underline font effect to the current title.

Fonts, font sizes, color and effects must be set individually for the Top, Bottom Left and Right titles.


Choose an item from the list.


Turn the display of legends on.


Check your desired options.


Check your desired options.


Check your desired options.


Enter a title to display to the right of the chart.


Enter a title to display at the top of the chart.


Enter a title to display at the bottom of the chart.


Enter a title to display to the left of the chart.


Select the Top title. Do this to enable the font style to be set for the Top title.


Select the Left title. Do this to enable the font style to be set for the Left title.


Select the Bottom title. Do this to enable the font style to be set for the Bottom title.


Select the Right title. Do this to enable the font style to be set for the Right title.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Enter a new name for the current series. This is used if legends are displayed.


Treat each data column as a series of values of a variable. The number of series displayed will match the number of columns in the data. The number of points for each series will match the number of rows in the data.


Treat each data row as a series of values of a variable. The number of series displayed will match the number of rows in the data. The number of points for each series will match the number of columns in the data.


Treat the values in the first column as labels.  For example, if you have the following data:

1	5

2	2

3	7

4	9

To display a single series, with labels, select First Column Labels. To display two series (and no labels), select First Column Data.


Treat the values in the first column as a series of data.  For example, if you have the following data:

1	5

2	2

3	7

4	9

To display a single series, with labels, select First Column Labels. To display two series (and no labels), select First Column Data.


Treat the values in the first row as labels.  For example, if you have the following data:

1	5	2	2

3	7	4	9

To display a single series, with labels, select First Row Labels. To display two series (and no labels), select First Row Data.


Treat the values in the first row as series of data.  For example, if you have the following data:

1	5	2	2

3	7	4	9

To display a single series, with labels, select First Row Labels. To display two series (and no labels), select First Row Data.


Go to the next page of the wizard.


Return to the previous page of the wizard.


Finish the chart with the chosen settings.


Cancel the chart.


Preview of the current settings.


Enter your input in this field.


Choose the data range to display as a chart. Include the row and column titles (if any) to have these displayed as labels.

A data range consists of a single one-dimensional (A1..A10) or two dimensional array (A1..E5).

Note, when creating a chart, first select the data range to avoid having to fill in this box.


Enter your input in this field.


Enter your input in this field.


Use the arrows to select your preferred value.


Select the style of chart to be used.

There are pie charts, histograms, X-Y scattergrams, Surface plots and so on.


Display grid lines or not. Choose from None, Horizontal, Vertical or Both.


Chose a color scheme: set this to Solid, Black and White patterns, or Color patterns.


Select Stack to add the values of the data points together for each series and plot one bar per series; select Stack 100% to display the stack as a percentage bar. This can only be used with Columns and Horizontal Bars.


Choose the point type for each series - this can be changed later for each individual series (see the Series command from the Chart menu).


Turn the display of legends on.


Enter a title to display to the right of the chart.


Enter a title to display at the top of the chart.


Enter a title to display at the bottom of the chart.


Enter a title to display to the left of the chart.


Treat each data column as a series of values of a variable. The number of series displayed will match the number of columns in the data. The number of points for each series will match the number of rows in the data.


Treat each data row as a series of values of a variable. The number of series displayed will match the number of rows in the data. The number of points for each series will match the number of columns in the data.


Treat the values in the first column as labels.  For example, if you have the following data:

1	5

2	2

3	7

4	9

To display a single series, with labels, select First Column Labels. To display two series (and no labels), select First Column Data.


Treat the values in the first column as a series of data.  For example, if you have the following data:

1	5

2	2

3	7

4	9

To display a single series, with labels, select First Column Labels. To display two series (and no labels), select First Column Data.


Treat the values in the first row as labels.  For example, if you have the following data:

1	5	2	2

3	7	4	9

To display a single series, with labels, select First Row Labels. To display two series (and no labels), select First Row Data.


Treat the values in the first row as series of data.  For example, if you have the following data:

1	5	2	2

3	7	4	9

To display a single series, with labels, select First Row Labels. To display two series (and no labels), select First Row Data.


Choose the data range to display as a chart. Include the row and column titles (if any) to have these displayed as labels.

A data range consists of a single one-dimensional (A1..A10) or two dimensional array (A1..E5).

Note, when creating a chart, first select the data range to avoid having to fill in this box.


List of available fonts on system.


List of font styles for current font.


List of font sizes for the current font and font style.


Draw a line through the text.


Draw a line underneath the text.


Select a color for the text.


Preview current settings.


Choose a script.


Check your desired options.


Check your desired options.


Check your desired options.


List of available fonts on system.


List of font styles for current font.


List of font sizes for the current font and font style.


Draw a line through the text.


Draw a line underneath the text.


Changes also apply to any fields within the selected text


Raise the selected text in a reduced font.


Lower the selected text in a reduced font.


Select a color for the text.


Preview current settings.


Choose a script.


Select from a list of date and time formats.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Scale the page so that the entire page width fits the window.


Scale the page so that the entire page fits the window.


Display several pages within the window.


Scale the page so that the text within the left and right margins fits the window.


Scale the page to custom % of the normal display.


Scale the page to custom % of the normal display.


Use the arrows to select your preferred value.


Drag the slider to select your preferred zoom value


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Closes this dialog and saves any changes you have made.


Copyright and licensing messages.


Copyright and licensing messages.


Copyright and licensing messages.


Click this button to make your choice.


The text to search for.

Each time text is entered, it is stored for reuse later. Use the drop-down button to access previous search text. Whenever you restart Write, the search items are cleared.


Apply extra conditions (if applicable).


For example, search for the text "the".

If this box is clear, search will find all occurrences of "the" and words like "antithesis".

If this box is checked, search will find only the word "the".


For example, search for the word "Ability".

If this box is clear, search will find all occurrences of "ability" and "Ability".

If this box is checked, search will find only the word "Ability".


Search from the beginning of the document (or selection) so every occurrence of the text will be found.


Search only the text above the current cursor position, going from the cursor to the top the document (or selection).


Search only the text below the current cursor position.


Search within the selected text only.


Search entire document.


Find the next occurrence of the text in "Find what" according to direction scope and other options.


Closes this dialog without saving any changes you have made.


Click this button to make your choice.


The text to search for.

Each time text is entered, it is stored for reuse later. Use the drop-down button to access previous search text. Whenever you restart Write, the search items are cleared.


Text to replace the found text with.

Leave this blank to delete the found text.


Apply extra conditions (if applicable).


For example, search for the text "the".

If this box is clear, search will find all occurrences of "the" and words like "antithesis".

If this box is checked, search will find only the word "the".


For example, search for the word "Ability".

If this box is clear, search will find all occurrences of "ability" and "Ability".

If this box is checked, search will find only the word "Ability".


Search from the beginning of the document (or selection) so every occurrence of the text will be found.


Search only the text above the current cursor position, going from the cursor to the top the document (or selection).


Search only the text below the current cursor position.


Search within the selected text only.


Search entire document.


Find the next occurrence of the text in "Find what" according to direction scope and other options.


Search and replace the next occurrence.


Search and replace every occurrence.


Closes this dialog without saving any changes you have made.


Click this button to make your choice.


Click this button to make your choice.


Click this button to make your choice.


Closes this dialog without saving any changes you have made.


Select your preferred option.


Select your preferred option.


Select your preferred option.


Select your preferred option.


Select your preferred option.


Enter your input in this field.


Use the arrows to select your preferred value.


Choose a font from the list.


Currently selected characters.


List of characters in the current font. Click to select and Double-click to insert into the "Characters to copy:" box.


Insert current character into "Characters to copy:" box.


Insert all the characters in the "Characters to copy:" box to the document and closes the dialog.


Close the dialog without inserting any symbols.


Select a toolbar category.


Shows all the buttons available within the current toolbar category.


Describes current button.


Display or remove toolbar.


Close the dialog.


Customize the toolbars. You can choose which buttons are displayed in every toolbar.


Rename the current toolbar.


Delete the current toolbar.


Display tooltips - the brief description of toolbar buttons in a yellow box.


Turn status bar on/off.


Coolbar Mode shows buttons on a flat toolbar. Turn this off to get standard Windows 95 raised buttons.


Display large buttons with short description.


Enter a new name for the toolbar.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Application used to create the document.


Enter a name here.


Enter keywords here. Keywords can be used with Comments to describe document contents.


Enter comments here. Comments can be used with Keywords to describe document contents.


A document title.


Document subject matter.


Template used to create document.


Displays who last saved the document. The name is taken from the Author field from the Summary page.


The total time the document has been worked on.


Date of the last occasion the document was printed.


Date of document creation.


Date of the last occasion the document was saved.


Total number of pages in the document.


Total number of words in the document, including a single count of header and footer text.


Total number of characters in the document, including a single count of header and footer text.

Note that spaces are included in the count.


How many times the document has been saved.


Preview the current settings.


Select from a color scheme set at the operating system level.


Set the mix of red for a custom color (0 = no red component, 255 means as much red as possible).


Increase or decrease the mix of red for a custom color (0 = no red component, 255 means as much red as possible).


Set the mix of green for a custom color (0 = no green component, 255 means as much green as possible).


Increase or decrease the mix of green for a custom color (0 = no green component, 255 means as much green as possible).


Set the mix of blue for a custom color (0 = no blue component, 255 means as much blue as possible).


Increase or decrease the mix of blue for a custom color (0 = no blue component, 255 means as much blue as possible).


Pick a color.


Pick a color.


Pick a color.


Pick a color.


Pick a color.


Pick a color.


Pick a color.


Pick a color.


Pick a color.


Pick a color.


Pick a color.


Pick a color.


Pick a color.


Pick a color.


Pick a color.


Pick a color.


The person the product is licensed to.

You should only change the Name if you have been supplied with full registration details from Ability Plus Software.


The Organization the product is licensed to.

You should only change the Organization if you have been supplied with full registration details from Ability Plus Software.


Product Key is a unique identifier for this product.

You should only change the Product Key if you have been supplied with full registration details from Ability Plus Software.


Closes this dialog and saves any changes you have made.


Closes this dialog without saving any changes you have made.


Displays current spell error.


Type of spell error found - could be a word miss-spelled or a repeated word.


Current "best guess" at the spell error - use the Change or Change To buttons to replace the current spell error with the contents of this box.


Suggestions for the current spell error, ranked from most likely to least likely.


Ignore this occurrence of the spell error.


Swap the current spell error with the word(s) in the Change To box.


Suggest some alternatives for the current spell error.

Use this button if "Always Suggest" is turned off under Tools/Options.

You can also pick a suggestion from the current list and request more suggestions.


Cancel the spell check.


Ignore all occurrences of the spell error in the document.


Swap all occurrences of the current spell error with the word(s) in the Change To box.


Add the current "spell error" to the personalized dictionary. Use this for commonly appearing proper nouns.

By default the personal dictionary is stored in USER.LEX.


Current word to find suggestions for.

This starts of as the selected word from the document. You can ask for further suggestions based on the found words.


Shows a broad meaning for the current word. A word might have several meanings, in which case they would be listed here, together with their parts of speech.


The synonym that matches most closely the current word. Use the Replace button to insert this word into your document.


A list of synonyms for the current word.

Click on one of these synonyms to place it in the Replace With box.

Double-click on a synonym to place it in the Looked Up box.


Replaces the selected word in the document with the word in the "Replace with Synonym" box.


Place the current synonym in the Looked Up box.


Closes this dialog without saving any changes you have made.


Step back through the contents of the Looked Up box.